UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'efQ968NQuwZU+pnj5732j14JCVvzjJfID8g940KyPzU='
WHERE
key_id = '57b2cedc3a0d817aa19ff8951b052aafb28a2e5e6c349668c8644387a1c1912a'
AND (
token = 'efQ968NQuwZU+pnj5732j14JCVvzjJfID8g940KyPzU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)