UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YN5Vz1yOwoNZSC1mautuHMsXvb6cXfd15N/OFc8eHLM='
WHERE
key_id = 'a338dfd931dc1d9a8e29453450a5c27d39f9f9b63865c1478e839aaf6b68a90e'
AND (
token = 'YN5Vz1yOwoNZSC1mautuHMsXvb6cXfd15N/OFc8eHLM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)