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