UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aip53vQiVsvEMDMUEMK6WceEEnCR9CcWXjF8LW8SMUo='
WHERE
key_id = '9a7cab54a2922e9c6c66ff0eccdaf59533bdd15b4ec801767ebecb02cc5d64a9'
AND (
token = 'aip53vQiVsvEMDMUEMK6WceEEnCR9CcWXjF8LW8SMUo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)