UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3UfR1HgmmPgks9fZrYIglD0dOsyodxbeR0lG8DwJSJ4='
WHERE
key_id = '29ab9e0c9ad6c81654b85eaa6d5c436e35f60623844ae86b62192482e30223ef'
AND (
token = '3UfR1HgmmPgks9fZrYIglD0dOsyodxbeR0lG8DwJSJ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)