UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rNQLbiKaKQHr4V+ODtUbXWCWgvA+cB2EtnezVuDiWZw='
WHERE
key_id = '6296e6022faa67c4d279302331c50fb7c4d6a58a0d36cb801fa31ae250510e49'
AND (
token = 'rNQLbiKaKQHr4V+ODtUbXWCWgvA+cB2EtnezVuDiWZw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)