UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CHuNoqS0pU7zoYbX5dCWTvE0s6sYuUu2U5/r95zh6fU='
WHERE
key_id = 'd4e9b5cbd3641a6731fd0fed1086cd0be49be02723c4d3cb18c7255059c67ea2'
AND (
token = 'CHuNoqS0pU7zoYbX5dCWTvE0s6sYuUu2U5/r95zh6fU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)