UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zsFdVco9IX4lNIiu1un2iZGbUOiKsDm9XlWTge3CUOg='
WHERE
key_id = '6b17e8dc3b116013084ee96d35cbb7a9dd10851344e135f3d88d223c99da46c2'
AND (
token = 'zsFdVco9IX4lNIiu1un2iZGbUOiKsDm9XlWTge3CUOg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)