UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yTtM8HfFlwyjQbrfm3j7Qh/fcVxPCHzeG/0ouV0YxoA='
WHERE
key_id = '3f58a6bb044d782611448c622ca66bd4920d0527236d5704a41f4fcba7b1a2a8'
AND (
token = 'yTtM8HfFlwyjQbrfm3j7Qh/fcVxPCHzeG/0ouV0YxoA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)