UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nxKSSsPjyVIVDzhYoLtH2itqT644zr3ef1hkmo9WKEA='
WHERE
key_id = '2258744c23fd84e9ba3106d65488a9c52ddf616591b544842a5359cfc14e40e4'
AND (
token = 'nxKSSsPjyVIVDzhYoLtH2itqT644zr3ef1hkmo9WKEA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)