UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J1bsrXRPOQXGcDbnF7tBAFkiyTpiE5WUVKk1s43TYAw='
WHERE
key_id = '5e246f1884061903140ab0fff28a1a3069d835fe46f2f3a78df2e5902b21a515'
AND (
token = 'J1bsrXRPOQXGcDbnF7tBAFkiyTpiE5WUVKk1s43TYAw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)