UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fwfAg5z2qhqp67nmDyZwgIdAehUsZGw6uWKEArNgdj8='
WHERE
key_id = '2bf0d7ae1ac363e2b3f9bfddd058cd06275072eddf8712de6ca175ed5a41df1c'
AND (
token = 'fwfAg5z2qhqp67nmDyZwgIdAehUsZGw6uWKEArNgdj8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)