UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v/tXZe2JpKok2YV74y+bXbssDUZGarnoAUqRoM9ejsY='
WHERE
key_id = 'c417837404df6c1680468c0efb46e9ad131a32be661f9ea7a983db1fe5b27ff6'
AND (
token = 'v/tXZe2JpKok2YV74y+bXbssDUZGarnoAUqRoM9ejsY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)