UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0lAdie47yHdZqZBxHlt7uhFRM8Bu56j8RX6MmOkw5+c='
WHERE
key_id = '40f6972819406936336bb62cf938e6896e046502bb3b3477a8c35b84cf1fe306'
AND (
token = '0lAdie47yHdZqZBxHlt7uhFRM8Bu56j8RX6MmOkw5+c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)