UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'crs71hf/y5RICmOxqAOplXEE4kMinXXr8kKFPifUnfU='
WHERE
key_id = 'f0c27eed65a406640fa7802a7c65885618e357888f3256381fe23c5b84ba07cd'
AND (
token = 'crs71hf/y5RICmOxqAOplXEE4kMinXXr8kKFPifUnfU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)