UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bxCWcyhe1ACvGqQpCOW9456mruab3IKx+3N9Vdm79A4='
WHERE
key_id = 'a546ba8591c76e3e3af4d6493b20b3db01461d50c55f2b2662f15ff5e17c8d3e'
AND (
token = 'bxCWcyhe1ACvGqQpCOW9456mruab3IKx+3N9Vdm79A4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)