UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nZdK6/8dfIZk+kSv24A6QJa+hmi8A1KP7MZ/KwzCBCM='
WHERE
key_id = '7e4b203fd77017761cb1c5da784eb8f5ef637782a9590081ebb7ee078a379ed6'
AND (
token = 'nZdK6/8dfIZk+kSv24A6QJa+hmi8A1KP7MZ/KwzCBCM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)