UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nZz3bm32ls1bucKdSPObz+XYfw2jkvrVvvWiSMItorw='
WHERE
key_id = '477d68b7fc3cc8a22b45e2d0a320b1f84b23324cab1c55d44fe9581968b13db5'
AND (
token = 'nZz3bm32ls1bucKdSPObz+XYfw2jkvrVvvWiSMItorw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)