UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x7uk4CG6Zc9oRvZUQ8QSmQITczJbiNrzGHKQghMXBWc='
WHERE
key_id = 'f310c34c818d007e02c04bedfd6d49e31b84d9a7e8de1f6f71a482a7a79c9bb5'
AND (
token = 'x7uk4CG6Zc9oRvZUQ8QSmQITczJbiNrzGHKQghMXBWc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)