UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bc1iKcFbk1CGyCEDs2tDGo9U4rCdo2KnahdA58NEoKU='
WHERE
key_id = '484f57388417f8501b5c4215b73b8440a7170602cc9322546bc9a4a5de27af43'
AND (
token = 'bc1iKcFbk1CGyCEDs2tDGo9U4rCdo2KnahdA58NEoKU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)