UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HrzNfOwl7Oicx2j0OlYRc1kp9u3wfCcJfRSQrpRz1cI='
WHERE
key_id = '744f2031a69ffef17351bdd83edb07010814121f65d9f5006c1799438702fab9'
AND (
token = 'HrzNfOwl7Oicx2j0OlYRc1kp9u3wfCcJfRSQrpRz1cI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)