UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z4d9piFuZTlig40CWBcs5f35XIREcMc8DY4aTANaZ4A='
WHERE
key_id = '9aa906734afdff697deb9b439406769a89a63999dea5cc6c06daef4cf80accd8'
AND (
token = 'z4d9piFuZTlig40CWBcs5f35XIREcMc8DY4aTANaZ4A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)