UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KZg2R2Gq3wfjWeFLw5kD2nfJxBFXwW03Yic458kxt8w='
WHERE
key_id = 'e7587fae26bddc190a26cda7e3dafd0e2552574b965267eeb1a8326ccbceed27'
AND (
token = 'KZg2R2Gq3wfjWeFLw5kD2nfJxBFXwW03Yic458kxt8w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)