UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZTHPOOF0XHwyL1SMt8OqZH8dLA7aP/6s+NFi+ecef0w='
WHERE
key_id = 'ea657aefe5a03c11e43a336f473e09d98740e7fe452cf9770ec045e4c190d8e4'
AND (
token = 'ZTHPOOF0XHwyL1SMt8OqZH8dLA7aP/6s+NFi+ecef0w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)