UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+Z95I+TciiDvEz7oYcPmGLmiCP69dicUwSLL8PeBf3I='
WHERE
key_id = 'b171bf88c07fb8efdf342cb29e1a4bb5c7774244de3fae45deae39b74c99583e'
AND (
token = '+Z95I+TciiDvEz7oYcPmGLmiCP69dicUwSLL8PeBf3I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)