UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3p0xnRshoosCQl9y5foOmSJ9Ytu4fHgX05zRyG++QFo='
WHERE
key_id = 'd2d74888c40e546397de2700bd70efe8141075557fb6768f2de309a93770bdd3'
AND (
token = '3p0xnRshoosCQl9y5foOmSJ9Ytu4fHgX05zRyG++QFo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)