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