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