UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HpbYRnxnCU0e2rY4x6PggjuJBu7a64xU4UaZluACzD8='
WHERE
key_id = '39a1f65efb62e7b47b86bf3530296d90f6a752f7793b5d6458e2fc58829ebcd8'
AND (
token = 'HpbYRnxnCU0e2rY4x6PggjuJBu7a64xU4UaZluACzD8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)