UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b7MxU9ZMS4OaMh7gvyDXWNCurk2E6ZdwMY6GJlKHOZM='
WHERE
key_id = '42f89573b34b5966e2f441416c70a1103006fd1a63de6a3eb3cdf62680eb7589'
AND (
token = 'b7MxU9ZMS4OaMh7gvyDXWNCurk2E6ZdwMY6GJlKHOZM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)