UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'T+0zTcBZsl9JrklPKe0spf5Sa0z5nTcuvPPek5yswpM='
WHERE
key_id = 'f45b526ea87bf4a8937eb9f060a14921531e065fd13a509be7a28f3a4b030f2e'
AND (
token = 'T+0zTcBZsl9JrklPKe0spf5Sa0z5nTcuvPPek5yswpM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)