UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eRyvkq2d61/vePsxrzHNkZ+DUxScBgWB5BQ7TpaKCTs='
WHERE
key_id = '8fcf764db296071d1aff3fe3c4e3c16b0afc0481257e8d7b3859ca53bb63c386'
AND (
token = 'eRyvkq2d61/vePsxrzHNkZ+DUxScBgWB5BQ7TpaKCTs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)